/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:8889
 Source Schema         : doudingimooc

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 17/04/2022 21:14:56
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` char(8) NOT NULL DEFAULT '' COMMENT 'id',
  `parent` char(8) NOT NULL DEFAULT '' COMMENT '父id',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `sort` int(11) DEFAULT NULL COMMENT '顺序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='分类';

-- ----------------------------
-- Records of category
-- ----------------------------
BEGIN;
INSERT INTO `category` VALUES ('00000100', '00000000', '前端技术', 100);
INSERT INTO `category` VALUES ('00000101', '00000100', 'html/css', 101);
INSERT INTO `category` VALUES ('00000102', '00000100', 'javascript', 102);
INSERT INTO `category` VALUES ('00000103', '00000100', 'vue.js', 103);
INSERT INTO `category` VALUES ('00000104', '00000100', 'react.js', 104);
INSERT INTO `category` VALUES ('00000105', '00000100', 'angular', 105);
INSERT INTO `category` VALUES ('00000106', '00000100', 'node.js', 106);
INSERT INTO `category` VALUES ('00000107', '00000100', 'jquery', 107);
INSERT INTO `category` VALUES ('00000108', '00000100', '小程序', 108);
INSERT INTO `category` VALUES ('00000200', '00000000', '后端技术', 200);
INSERT INTO `category` VALUES ('00000201', '00000200', 'java', 201);
INSERT INTO `category` VALUES ('00000202', '00000200', 'springboot', 202);
INSERT INTO `category` VALUES ('00000203', '00000200', 'spring cloud', 203);
INSERT INTO `category` VALUES ('00000204', '00000200', 'ssm', 204);
INSERT INTO `category` VALUES ('00000205', '00000200', 'python', 205);
INSERT INTO `category` VALUES ('00000206', '00000200', '爬虫', 206);
INSERT INTO `category` VALUES ('00000300', '00000000', '移动开发', 300);
INSERT INTO `category` VALUES ('00000301', '00000300', 'android', 301);
INSERT INTO `category` VALUES ('00000302', '00000300', 'ios', 302);
INSERT INTO `category` VALUES ('00000303', '00000300', 'react native', 303);
INSERT INTO `category` VALUES ('00000304', '00000300', 'ionic', 304);
INSERT INTO `category` VALUES ('00000400', '00000000', '前沿技术', 400);
INSERT INTO `category` VALUES ('00000401', '00000400', '微服务', 401);
INSERT INTO `category` VALUES ('00000402', '00000400', '区块链', 402);
INSERT INTO `category` VALUES ('00000403', '00000400', '机器学习', 403);
INSERT INTO `category` VALUES ('00000404', '00000400', '深度学习', 404);
INSERT INTO `category` VALUES ('00000405', '00000400', '数据分析&挖掘', 405);
INSERT INTO `category` VALUES ('00000500', '00000000', '云计算&大数据', 500);
INSERT INTO `category` VALUES ('00000501', '00000500', '大数据', 501);
INSERT INTO `category` VALUES ('00000502', '00000500', 'hadoop', 502);
INSERT INTO `category` VALUES ('00000503', '00000500', 'spark', 503);
INSERT INTO `category` VALUES ('00000504', '00000500', 'hbase', 504);
INSERT INTO `category` VALUES ('00000505', '00000500', '阿里云', 505);
INSERT INTO `category` VALUES ('00000506', '00000500', 'docker', 506);
INSERT INTO `category` VALUES ('00000507', '00000500', 'kubernetes', 507);
INSERT INTO `category` VALUES ('00000600', '00000000', '运维&测试', 600);
INSERT INTO `category` VALUES ('00000601', '00000600', '运维', 601);
INSERT INTO `category` VALUES ('00000602', '00000600', '自动化运维', 602);
INSERT INTO `category` VALUES ('00000603', '00000600', '中间件', 603);
INSERT INTO `category` VALUES ('00000604', '00000600', 'linux', 604);
INSERT INTO `category` VALUES ('00000605', '00000600', '测试', 605);
INSERT INTO `category` VALUES ('00000606', '00000600', '自动化测试', 606);
INSERT INTO `category` VALUES ('00000700', '00000000', '数据库', 700);
INSERT INTO `category` VALUES ('00000701', '00000700', 'mysql', 701);
INSERT INTO `category` VALUES ('00000702', '00000700', 'redis', 702);
INSERT INTO `category` VALUES ('00000703', '00000700', 'mongodb', 703);
COMMIT;

-- ----------------------------
-- Table structure for chapter
-- ----------------------------
DROP TABLE IF EXISTS `chapter`;
CREATE TABLE `chapter` (
  `id` char(8) NOT NULL COMMENT 'id',
  `course_id` char(8) DEFAULT NULL COMMENT '课程id',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='大章';

-- ----------------------------
-- Records of chapter
-- ----------------------------
BEGIN;
INSERT INTO `chapter` VALUES ('00000005', '00000000', '测试大章05');
INSERT INTO `chapter` VALUES ('00000006', '00000000', '测试大章06');
INSERT INTO `chapter` VALUES ('00000007', '00000000', '测试大章07');
INSERT INTO `chapter` VALUES ('00000008', '00000000', '测试大章08');
INSERT INTO `chapter` VALUES ('00000009', '00000000', '测试大章09');
INSERT INTO `chapter` VALUES ('00000010', '00000000', '测试大章10');
INSERT INTO `chapter` VALUES ('00000011', '00000000', '测试大章11');
INSERT INTO `chapter` VALUES ('00000012', '00000000', '测试大章12');
INSERT INTO `chapter` VALUES ('00000013', '00000000', '测试大章13');
INSERT INTO `chapter` VALUES ('00000014', '00000000', '测试大章14');
INSERT INTO `chapter` VALUES ('5ylAKc7S', 'vsQz6xVD', '第一章环境搭建');
INSERT INTO `chapter` VALUES ('abc6vQqI', 'a2UqvQqI', '第一章数据类型新的');
INSERT INTO `chapter` VALUES ('Bjn05tVf', 'vsQz6xVD', '第二章基础语法');
INSERT INTO `chapter` VALUES ('cba7vQqI', 'a2UqvQqI', '第二章逻辑判断');
INSERT INTO `chapter` VALUES ('joNazvd8', 'vsQz6xVD', '第三章逻辑判断');
INSERT INTO `chapter` VALUES ('lYCqsU7s', 'vsQz6xVD', '第四章MVC');
INSERT INTO `chapter` VALUES ('mUyCPfwJ', 'vsQz6xVD', '第五章数据库操作');
INSERT INTO `chapter` VALUES ('ncc9vQqI', 'a2UqvQqI', '第三章循环');
INSERT INTO `chapter` VALUES ('spfPgpSO', 'a2UqvQqI', '新增项目');
INSERT INTO `chapter` VALUES ('SQjlJRA9', 'a2UqvQqI', '第四章Java函数');
COMMIT;

-- ----------------------------
-- Table structure for course
-- ----------------------------
DROP TABLE IF EXISTS `course`;
CREATE TABLE `course` (
  `id` char(8) NOT NULL DEFAULT '' COMMENT 'id',
  `name` varchar(50) NOT NULL COMMENT '名称',
  `summary` varchar(2000) DEFAULT NULL COMMENT '概述',
  `time` int(11) DEFAULT '0' COMMENT '时长|单位秒',
  `price` decimal(8,2) DEFAULT '0.00' COMMENT '价格（元）',
  `image` varchar(100) DEFAULT NULL COMMENT '封面',
  `level` char(1) DEFAULT NULL COMMENT '级别|枚举[doudingLevelEnum]：ONE("1", "初级"),TWO("2", "中级"),THREE("3", "高级")',
  `charge` char(1) DEFAULT NULL COMMENT '收费|枚举[doudingChargeEnum]：CHARGE("C", "收费"),FREE("F", "免费")',
  `status` char(1) DEFAULT NULL COMMENT '状态|枚举[doudingStatusEnum]：PUBLISH("P", "发布"),DRAFT("D", "草稿")',
  `enroll` int(11) DEFAULT '0' COMMENT '报名数',
  `sort` int(11) DEFAULT NULL COMMENT '顺序',
  `created_at` datetime(3) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(3) DEFAULT NULL COMMENT '修改时间',
  `teacher_id` char(8) DEFAULT NULL COMMENT '讲师|teacher.id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='课程';

-- ----------------------------
-- Records of course
-- ----------------------------
BEGIN;
INSERT INTO `course` VALUES ('a2UqvQqI', 'Java企业是实战课程', 'React — 大厂前端必备的技能点，本课程将带你系统学习 React 17 的完整技术体系，并结合 TypeScript 开发热门业务应用，实现对于框架的深度掌握，助你提升硬实力，快人一步进大厂。', 1179, 12.80, 'https://douding-course.oss-cn-beijing.aliyuncs.com/course/20ssDk0gqQGmo0q6YWI4i.jpg', '2', 'C', 'P', 111, 2, '2021-08-03 16:55:22.000', '2021-08-23 11:19:14.103', 'zxJ2ebX9');
INSERT INTO `course` VALUES ('EOFErD7x', '移动应用开发', 'React — 大厂前端必备的技能点，本课程将带你系统学习 React 17 的完整技术体系，并结合 TypeScript 开发热门业务应用，实现对于框架的深度掌握，助你提升硬实力，快人一步进大厂React — 大厂前端必备的技能点，本课程将带你系统学习 React 17 的完整技术体系，并结合 TypeScript 开发热门业务应用，实现对于框架的深度掌握，助你提升硬实力，快人一步进大厂', NULL, 100.00, 'https://douding-course.oss-cn-beijing.aliyuncs.com/course/3xzByd6GCMOocGK0qIa0kI.jpg', '2', 'F', 'P', 1111, 3, '2021-08-19 10:05:08.000', '2022-04-15 13:11:32.633', '5vkSWyOp');
INSERT INTO `course` VALUES ('EQaDRgc9', 'Vue3', 'React — 大厂前端必备的技能点，本课程将带你系统学习 React 17 的完整技术体系，并结合 TypeScript 开发热门业务应用，实现对于框架的深度掌握，助你提升硬实力，快人一步进大厂,React — 大厂前端必备的技能点，本课程将带你系统学习 React 17 的完整技术体系，并结合 TypeScript 开发热门业务应用，实现对于框架的深度掌握，助你提升硬实力，快人一步进大厂', 1, 100.00, 'https://douding-course.oss-cn-beijing.aliyuncs.com/course/19xGddgWsYUEImuQSOM6i6.jpg', '2', 'C', 'P', 1, 4, '2021-08-05 22:46:00.000', '2022-04-15 13:11:26.390', 'I4IzEnVI');
INSERT INTO `course` VALUES ('vsQz6xVD', 'PHP课程企业实战课程', 'React — 大厂前端必备的技能点，本课程将带你系统学习 React 17 的完整技术体系，并结合 TypeScript 开发热门业务应用，实现对于框架的深度掌握，助你提升硬实力，快人一步进大厂。', 71, 123.00, 'https://douding-course.oss-cn-beijing.aliyuncs.com/course/4MYfgGg63CaS0qQAqeYKoo.jpg', '3', 'F', 'P', 1, 1, '2021-08-04 10:29:15.000', '2021-08-23 11:20:53.200', 'KU5kizJz');
COMMIT;

-- ----------------------------
-- Table structure for course_category
-- ----------------------------
DROP TABLE IF EXISTS `course_category`;
CREATE TABLE `course_category` (
  `id` char(8) NOT NULL DEFAULT '' COMMENT 'id',
  `course_id` char(8) DEFAULT NULL COMMENT '课程|course.id',
  `category_id` char(8) DEFAULT NULL COMMENT '分类|course.id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='课程分类';

-- ----------------------------
-- Records of course_category
-- ----------------------------
BEGIN;
INSERT INTO `course_category` VALUES ('1CynWoPQ', 'a2UqvQqI', '00000701');
INSERT INTO `course_category` VALUES ('2zqd4eu1', 'EOFErD7x', '00000304');
INSERT INTO `course_category` VALUES ('3CPmssA1', 'a2UqvQqI', '00000700');
INSERT INTO `course_category` VALUES ('5So76Y4w', 'yZtFpvnu', '00000203');
INSERT INTO `course_category` VALUES ('6MjgD1FU', 'EQaDRgc9', '00000106');
INSERT INTO `course_category` VALUES ('amorFXtk', 'EOFErD7x', '00000301');
INSERT INTO `course_category` VALUES ('AR4THUR9', 'D9kYvIk5', '00000204');
INSERT INTO `course_category` VALUES ('armBMjiS', 'yZtFpvnu', '00000204');
INSERT INTO `course_category` VALUES ('Cdd8Cvu5', 'EQaDRgc9', '00000108');
INSERT INTO `course_category` VALUES ('e66xtxN5', 'EQaDRgc9', '00000100');
INSERT INTO `course_category` VALUES ('EPgQ9s7Z', 'D9kYvIk5', '00000206');
INSERT INTO `course_category` VALUES ('F6N2wtv0', 'D9kYvIk5', '00000200');
INSERT INTO `course_category` VALUES ('HlCjRYC3', 'D9kYvIk5', '00000203');
INSERT INTO `course_category` VALUES ('hoWDhQf4', 'EOFErD7x', '00000302');
INSERT INTO `course_category` VALUES ('huCocl25', 'EOFErD7x', '00000303');
INSERT INTO `course_category` VALUES ('iJ6RCMmH', 'yZtFpvnu', '00000200');
INSERT INTO `course_category` VALUES ('kKpLhkGv', 'a2UqvQqI', '00000703');
INSERT INTO `course_category` VALUES ('l1kKBiAU', 'D9kYvIk5', '00000201');
INSERT INTO `course_category` VALUES ('nG9hCRjk', 'yZtFpvnu', '00000206');
INSERT INTO `course_category` VALUES ('Nmn47EnF', 'EOFErD7x', '00000300');
INSERT INTO `course_category` VALUES ('OnbASxqJ', 'a2UqvQqI', '00000702');
INSERT INTO `course_category` VALUES ('ptJQ4Q1t', 'yZtFpvnu', '00000202');
INSERT INTO `course_category` VALUES ('RaZdLpLn', 'vsQz6xVD', '00000100');
INSERT INTO `course_category` VALUES ('rL1R2hl7', 'yZtFpvnu', '00000201');
INSERT INTO `course_category` VALUES ('U6X0RQsB', 'D9kYvIk5', '00000202');
INSERT INTO `course_category` VALUES ('WXSpu9hw', 'yZtFpvnu', '00000205');
INSERT INTO `course_category` VALUES ('xzmXPQmt', 'vsQz6xVD', '00000101');
INSERT INTO `course_category` VALUES ('Z0Ra0YH2', 'D9kYvIk5', '00000205');
COMMIT;

-- ----------------------------
-- Table structure for course_content
-- ----------------------------
DROP TABLE IF EXISTS `course_content`;
CREATE TABLE `course_content` (
  `id` char(8) NOT NULL DEFAULT '' COMMENT '课程id',
  `content` mediumtext NOT NULL COMMENT '课程内容',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='课程内容';

-- ----------------------------
-- Records of course_content
-- ----------------------------
BEGIN;
INSERT INTO `course_content` VALUES ('a2UqvQqI', '<p><img src=\"http://127.0.0.1:9000/file/f/course/OK82AzTe.jpeg	\" style=\"width: 400px;\">这是测试的内容啊</p>');
INSERT INTO `course_content` VALUES ('EOFErD7x', '');
INSERT INTO `course_content` VALUES ('EQaDRgc9', '<p><span style=\"color: rgb(102, 102, 102); font-family: 微软雅黑; font-size: 14px;\">本课程为Vue2.0版本，Vue是渐进式JavaScript框架，并且易用、灵活和高效的。进两年Vue框架的使用是最多的了。从百度指数与微信指数中不难看到。本课程主要讲解的内容为：环境搭建、基本指令、组件的使用、数据交互、网络请求、路由处理、第三方常用组件库同时最后添加项目，用来熟悉以上知识点。基本涵盖了API中大部分的常用知识点。</span><br style=\"color: rgb(102, 102, 102); font-family: 微软雅黑; font-size: 14px;\"><br style=\"color: rgb(102, 102, 102); font-family: 微软雅黑; font-size: 14px;\"><span style=\"color: rgb(102, 102, 102); font-family: 微软雅黑; font-size: 14px;\">　　本课程学习前，建议有一定的HTML、CSS、JS基础。并且，最好掌握了Webpack构建工具与ES6的基本语法。学起来会更加轻松。后续会更新关于Vue在项目中的最佳实践相关的课程。</span><br></p>');
INSERT INTO `course_content` VALUES ('vsQz6xVD', '<p><span style=\"color: rgb(85, 85, 85); font-family: -apple-system, system-ui, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, Arial, &quot;Noto Sans&quot;, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;, &quot;Noto Color Emoji&quot;; font-size: 16px; background-color: rgb(248, 249, 250);\">React — 大厂前端必</span><img src=\"\" style=\"width: 662px;\" data-filename=\"截屏2022-04-15 上午11.38.44.png\"></p>');
COMMIT;

-- ----------------------------
-- Table structure for course_content_file
-- ----------------------------
DROP TABLE IF EXISTS `course_content_file`;
CREATE TABLE `course_content_file` (
  `id` char(8) NOT NULL DEFAULT '' COMMENT 'id',
  `course_id` char(8) NOT NULL COMMENT '课程id',
  `url` varchar(100) DEFAULT NULL COMMENT '地址',
  `name` varchar(100) DEFAULT NULL COMMENT '文件名',
  `size` int(11) DEFAULT NULL COMMENT '大小|字节b',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='课程内容文件';

-- ----------------------------
-- Records of course_content_file
-- ----------------------------
BEGIN;
INSERT INTO `course_content_file` VALUES ('0inb92qM', 'a2UqvQqI', 'http://127.0.0.1:9000/file/f/course/biM0x4JU.jpeg', '1.jpeg', 42678);
COMMIT;

-- ----------------------------
-- Table structure for file
-- ----------------------------
DROP TABLE IF EXISTS `file`;
CREATE TABLE `file` (
  `id` char(8) NOT NULL DEFAULT '' COMMENT 'id',
  `path` varchar(100) NOT NULL COMMENT '相对路径',
  `name` varchar(100) DEFAULT NULL COMMENT '文件名',
  `suffix` varchar(10) DEFAULT NULL COMMENT '后缀',
  `size` int(11) DEFAULT NULL COMMENT '大小|字节B',
  `use` char(1) DEFAULT NULL COMMENT '用途|枚举[FileUseEnum]：course("C", "讲师"), TEACHER("T", "课程")',
  `created_at` datetime(3) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(3) DEFAULT NULL COMMENT '修改时间',
  `shard_index` int(11) DEFAULT NULL COMMENT '已上传分片',
  `shard_size` int(11) DEFAULT NULL COMMENT '分片大小|B',
  `shard_total` int(11) DEFAULT NULL COMMENT '分片总数',
  `key` varchar(32) DEFAULT NULL COMMENT '文件标识',
  PRIMARY KEY (`id`),
  UNIQUE KEY `path_unique` (`path`),
  UNIQUE KEY `key_unique` (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文件';

-- ----------------------------
-- Records of file
-- ----------------------------
BEGIN;
INSERT INTO `file` VALUES ('1upDlP0K', 'course/7tEMQAf3RmOImgQ4QaU4UY.mp4', 'newCF精彩视频.mp4', 'mp4', 1854103, 'C', '2021-08-12 14:56:34.272', '2021-08-12 14:56:34.272', 1, 10485760, 1, '7tEMQAf3RmOImgQ4QaU4UY');
INSERT INTO `file` VALUES ('2i3Fmrlq', 'teacher/7qnRoD49dSo68M0yUoK4KW.png', '截屏2022-04-15 上午11.35.21.png', 'png', 739437, 'T', '2022-04-15 11:37:27.015', '2022-04-15 11:37:27.015', 1, 5242880, 1, '7qnRoD49dSo68M0yUoK4KW');
INSERT INTO `file` VALUES ('36j0hHaY', 'teacher/2hQrYvF4OoqSKoYYU28ImK.png', '截屏2022-04-15 上午11.38.11.png', 'png', 646392, 'T', '2022-04-15 11:38:27.676', '2022-04-15 11:38:27.676', 1, 5242880, 1, '2hQrYvF4OoqSKoYYU28ImK');
INSERT INTO `file` VALUES ('3tLc4yUP', 'course/owcAX0qw.blob', 'blob', 'blob', 20971520, 'C', '2021-08-10 12:13:35.708', '2021-08-10 12:13:35.708', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('5ccHQqIq', 'teacher/4KdQK79s0gmmQsAacGIWwQ.png', '截屏2022-04-15 下午1.42.25.png', 'png', 1484753, 'T', '2022-04-15 13:42:37.128', '2022-04-15 13:42:37.128', 1, 5242880, 1, '4KdQK79s0gmmQsAacGIWwQ');
INSERT INTO `file` VALUES ('64g7lS6o', 'teacher/m9OyYhsL.jpeg', '1.jpeg', 'jpeg', 42678, 'T', '2021-08-08 13:18:19.381', '2021-08-08 13:18:19.381', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('6wQj6QJE', 'course/BTMqxzqo.mp4', 'c2.mp4', 'mp4', 21492913, 'C', '2021-08-08 12:54:12.966', '2021-08-08 12:54:12.966', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('7kTgSEnL', 'teacher/7EPGggGEycAAIsyQQuY8I0.jpeg', 'header4.jpeg', 'jpeg', 192023, 'T', '2021-08-14 13:39:22.519', '2021-08-14 13:39:22.519', 1, 5242880, 1, '7EPGggGEycAAIsyQQuY8I0');
INSERT INTO `file` VALUES ('8T1CDbWV', 'course/2Pr2sbW8XKKA40MuAwUuk.mp4', 'dianying.mp4', 'mp4', 30088323, 'C', '2021-08-12 14:28:52.623', '2021-08-12 14:29:02.203', 6, 5242880, 6, '2Pr2sbW8XKKA40MuAwUuk');
INSERT INTO `file` VALUES ('9g4Ktug3', 'teachers/RpqFfddf.jpeg', '1.jpeg', 'jpeg', 42678, '', '2021-08-08 10:43:45.273', '2021-08-08 10:43:45.273', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('bdnzLA4E', 'teacher/6tX8xASa64o26u6AEUa0I2.jpeg', 'header2.jpeg', 'jpeg', 23099, 'T', '2021-08-12 20:33:45.404', '2021-08-12 20:33:45.404', 1, 5242880, 1, '6tX8xASa64o26u6AEUa0I2');
INSERT INTO `file` VALUES ('bOSOlZcs', 'course/rLoD84l1.jpeg', '1.jpeg', 'jpeg', 42678, 'C', '2021-08-08 21:30:51.882', '2021-08-08 21:30:51.882', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('bs0Sbn04', 'course/2ZDnYBua.blob', 'blob', 'blob', 20971520, 'C', '2021-08-10 12:12:11.709', '2021-08-10 12:12:11.709', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('cEChs8tO', 'course/jUep5ptY.jpeg', 'header1.jpeg', 'jpeg', 49592, 'C', '2021-08-08 13:23:03.629', '2021-08-08 13:23:03.629', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('cTWBueh2', 'course/biM0x4JU.jpeg', '1.jpeg', 'jpeg', 42678, 'C', '2021-08-10 09:49:24.917', '2021-08-10 09:49:24.917', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('Di8xBLQS', 'course/19xGddgWsYUEImuQSOM6i6.jpg', '课程封面5.jpg', 'jpg', 210224, 'C', '2021-08-19 09:54:23.349', '2021-08-19 09:54:23.349', 1, 5242880, 1, '19xGddgWsYUEImuQSOM6i6');
INSERT INTO `file` VALUES ('dVy6EWo6', 'course/iEAaN9ti.jpeg', 'header1.jpeg', 'jpeg', 49592, 'C', '2021-08-08 12:17:44.933', '2021-08-08 12:17:44.933', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('dZSSKZfd', 'course/3xzByd6GCMOocGK0qIa0kI.jpg', '课程封面1.jpg', 'jpg', 92975, 'C', '2021-08-19 10:04:20.165', '2021-08-19 10:04:20.165', 1, 5242880, 1, '3xzByd6GCMOocGK0qIa0kI');
INSERT INTO `file` VALUES ('e40mLfzo', 'teachers/ujZASZXi.jpeg', 'header1.jpeg', 'jpeg', 49592, '', '2021-08-08 11:22:11.707', '2021-08-08 11:22:11.707', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('EgVy8o2w', 'course/3z9XEYOO.jpeg', 'header2.jpeg', 'jpeg', 23099, 'C', '2021-08-08 12:21:05.554', '2021-08-08 12:21:05.554', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('emmuReAj', 'teacher/OgfgDeDz.jpeg', 'header1.jpeg', 'jpeg', 49592, 'T', '2021-08-08 13:22:35.275', '2021-08-08 13:22:35.275', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('EQj2dMC6', 'teacher/4MUPL5gwYwWEQmqSgigieq.png', '截屏2022-04-15 上午11.39.32.png', 'png', 1052963, 'T', '2022-04-15 11:39:45.965', '2022-04-15 11:39:45.965', 1, 5242880, 1, '4MUPL5gwYwWEQmqSgigieq');
INSERT INTO `file` VALUES ('Ga1opBIP', 'teacher/1AAsybGY20oWGg64cGO0ya.png', '截屏2022-04-15 上午11.38.44.png', 'png', 638266, 'T', '2022-04-15 11:38:57.717', '2022-04-15 11:38:57.717', 1, 5242880, 1, '1AAsybGY20oWGg64cGO0ya');
INSERT INTO `file` VALUES ('h9I1cNTG', 'teacher/xNv5cw0o.jpeg', 'header1.jpeg', 'jpeg', 49592, 'T', '2021-08-08 12:03:53.227', '2021-08-08 12:03:53.227', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('HbunE3tK', 'course/OK82AzTe.jpeg', 'header2.jpeg', 'jpeg', 23099, 'C', '2021-08-08 21:38:09.692', '2021-08-08 21:38:09.692', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('hh8TAuES', 'teacher/3dGpCsayYEaYMk8aoQowkc.png', '截屏2022-04-15 下午1.40.50.png', 'png', 858077, 'T', '2022-04-15 13:41:04.437', '2022-04-15 13:41:04.437', 1, 5242880, 1, '3dGpCsayYEaYMk8aoQowkc');
INSERT INTO `file` VALUES ('HnN2a4rR', 'teacher/5oMBEMSmKQ4AYyiGUQ0geq.png', '截屏2022-04-15 上午11.34.24.png', 'png', 946168, 'T', '2022-04-15 11:37:39.269', '2022-04-15 11:37:39.269', 1, 5242880, 1, '5oMBEMSmKQ4AYyiGUQ0geq');
INSERT INTO `file` VALUES ('J0RPi7xp', 'teacher/48zKn6HGFuecsSaqG0mgcQ.png', '截屏2022-04-15 下午1.40.13.png', 'png', 712877, 'T', '2022-04-15 13:40:26.785', '2022-04-15 13:40:26.785', 1, 5242880, 1, '48zKn6HGFuecsSaqG0mgcQ');
INSERT INTO `file` VALUES ('jRnLMVHN', 'course/Wb5GRmOr.blob', 'blob', 'blob', 20971520, 'C', '2021-08-10 12:14:59.665', '2021-08-10 12:14:59.665', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('Kaz04Ryw', 'teacher/16eJOr8H.jpeg', '1.jpeg', 'jpeg', 42678, 'T', '2021-08-08 12:05:52.071', '2021-08-08 12:05:52.071', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('kcFaFxLM', 'teacher/7Ds5xR5i7KC8u0UOCGqYw4.png', '截屏2022-04-15 下午1.43.48.png', 'png', 1453613, 'T', '2022-04-15 13:43:59.287', '2022-04-15 13:43:59.287', 1, 5242880, 1, '7Ds5xR5i7KC8u0UOCGqYw4');
INSERT INTO `file` VALUES ('ly75xwKt', 'teacher/4cIRrG417ymMYwKaI8Oc6a.png', '截屏2022-04-15 下午1.43.08.png', 'png', 1447533, 'T', '2022-04-15 13:43:20.612', '2022-04-15 13:43:20.612', 1, 5242880, 1, '4cIRrG417ymMYwKaI8Oc6a');
INSERT INTO `file` VALUES ('mZrnmgpz', 'course/yPsGtSOh.mp4', 'c1.mp4', 'mp4', 1854103, 'C', '2021-08-08 13:23:55.431', '2021-08-08 13:23:55.431', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('N1khlND4', 'course/c082WcOi.jpeg', 'header2.jpeg', 'jpeg', 23099, 'C', '2021-08-08 12:17:59.656', '2021-08-08 12:17:59.656', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('NZrvdCrt', 'course/07afUc3j.jpeg', 'header4.jpeg', 'jpeg', 192023, 'C', '2021-08-08 21:19:01.120', '2021-08-08 21:19:01.120', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('o9MTLBlQ', 'teacher/7ggwV8hOoWEUaCUCei44S.png', '截屏2022-04-15 上午11.36.19.png', 'png', 703522, 'T', '2022-04-15 11:36:42.157', '2022-04-15 11:36:42.157', 1, 5242880, 1, '7ggwV8hOoWEUaCUCei44S');
INSERT INTO `file` VALUES ('ObXPov7j', 'course/BIOUWZHx.jpeg', 'header1.jpeg', 'jpeg', 49592, 'C', '2021-08-08 21:05:49.498', '2021-08-08 21:05:49.498', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('oWpC3r8i', 'course/20ssDk0gqQGmo0q6YWI4i.jpg', '课程封面3.jpg', 'jpg', 109121, 'C', '2021-08-19 09:55:04.838', '2021-08-19 09:55:04.838', 1, 5242880, 1, '20ssDk0gqQGmo0q6YWI4i');
INSERT INTO `file` VALUES ('pU9u8O1r', 'course/yrCpWCpIbeKeWQKWmkk6O.mp4', 'CF精彩视频.mp4', 'mp4', 1854103, 'C', '2021-08-12 14:30:56.707', '2021-08-12 14:30:56.707', 1, 5242880, 1, 'yrCpWCpIbeKeWQKWmkk6O');
INSERT INTO `file` VALUES ('Q6SDv9uO', 'course/6SerKOYB.jpeg', 'header2.jpeg', 'jpeg', 23099, 'C', '2021-08-08 12:19:20.063', '2021-08-08 12:19:20.063', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('QfneQZzv', 'teacher/omduT7lQ.jpeg', 'header4.jpeg', 'jpeg', 192023, 'T', '2021-08-08 13:22:45.383', '2021-08-08 13:22:45.383', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('quPc1PdD', 'course/njLG1sIP.mp4', 'c2.mp4', 'mp4', 21492913, 'C', '2021-08-08 13:00:30.506', '2021-08-08 13:00:30.506', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('r416z69u', 'course/2ItYt9ZK.mp4', 'c2.mp4', 'mp4', 21492913, 'C', '2021-08-08 12:56:30.104', '2021-08-08 12:56:30.104', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('RhVjA4Dz', 'course/MQvXhqJt.jpeg', 'header3.jpeg', 'jpeg', 25985, 'C', '2021-08-08 21:21:36.835', '2021-08-08 21:21:36.835', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('S7b43nhj', 'course/YDvGbMD6.mp4', 'c2.mp4', 'mp4', 21492913, 'C', '2021-08-08 12:55:17.723', '2021-08-08 12:55:17.723', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('SKtBe2Pr', 'course/rnaql56R.mp4', 'c2.mp4', 'mp4', 21492913, 'C', '2021-08-08 13:11:36.633', '2021-08-08 13:11:36.633', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('T6Vzpi3V', 'course/4MYfgGg63CaS0qQAqeYKoo.jpg', '课程封面4.jpg', 'jpg', 110369, 'C', '2021-08-19 14:35:21.262', '2021-08-19 14:35:21.262', 1, 5242880, 1, '4MYfgGg63CaS0qQAqeYKoo');
INSERT INTO `file` VALUES ('tJszF3c2', 'course/6bdQgA9b5CawKigiSowIKe.mp4', 'html是什么 - 飞秒生活.mp4', 'mp4', 39182139, 'C', '2022-04-15 13:25:42.955', '2022-04-15 13:25:47.901', 4, 10485760, 4, '6bdQgA9b5CawKigiSowIKe');
INSERT INTO `file` VALUES ('tLTKgw3q', 'course/1tBsLkQHuskqSa0gC2qWeE.mp4', 'c2.mp4', 'mp4', 21492913, 'C', '2021-08-12 14:19:38.083', '2021-08-12 14:19:46.559', 5, 5242880, 5, '1tBsLkQHuskqSa0gC2qWeE');
INSERT INTO `file` VALUES ('VeKJ9zHl', 'course/L8A01prs.blob', 'blob', 'blob', 20971520, 'C', '2021-08-10 12:17:10.529', '2021-08-10 12:17:10.529', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('VksTzDBd', 'course/qERqcats.mp4', 'c1.mp4', 'mp4', 1854103, 'C', '2021-08-08 13:41:01.871', '2021-08-08 13:41:01.871', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('vv0KlkeP', 'course/sN7OTgoMpiyMqUGcoMSWu.mp4', 'cf手游视频.mp4', 'mp4', 21492913, 'C', '2021-08-12 14:38:07.669', '2021-08-12 14:38:12.612', 3, 10485760, 3, 'sN7OTgoMpiyMqUGcoMSWu');
INSERT INTO `file` VALUES ('W4j8OSbx', 'course/4K3OKKLA80ikuwkAQgMmqG.mp4', 'new1.mp4', 'mp4', 1854103, 'C', '2021-08-12 15:04:56.671', '2021-08-12 15:04:56.671', 1, 10485760, 1, '4K3OKKLA80ikuwkAQgMmqG');
INSERT INTO `file` VALUES ('W4vwOdr8', 'teacher/1G3gmg8wgA4aK0q0yQQsQS.jpeg', 'header3.jpeg', 'jpeg', 25985, 'T', '2021-08-12 20:35:12.742', '2021-08-12 20:35:12.742', 1, 5242880, 1, '1G3gmg8wgA4aK0q0yQQsQS');
INSERT INTO `file` VALUES ('X4hP7rhX', 'course/tw8Pt14y.jpeg', 'header1.jpeg', 'jpeg', 49592, 'C', '2021-08-08 21:03:35.107', '2021-08-08 21:03:35.107', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('XABHde1M', 'course/YUm4Zkx2.jpeg', 'header1.jpeg', 'jpeg', 49592, 'C', '2021-08-08 12:31:55.585', '2021-08-08 12:31:55.585', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('Ydh3I2oy', 'course/mM31smlB.jpeg', '1.jpeg', 'jpeg', 42678, 'C', '2021-08-08 21:37:04.537', '2021-08-08 21:37:04.537', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('yqr3y4SA', 'teacher/pbaVBBnF.jpeg', '1.jpeg', 'jpeg', 42678, 'T', '2021-08-08 11:38:03.228', '2021-08-08 11:38:03.228', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('YUjf2l5a', 'course/6Bwc7FRQ.jpeg', '1.jpeg', 'jpeg', 42678, 'C', '2021-08-08 21:13:29.114', '2021-08-08 21:13:29.114', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('z6Hg2Ual', 'course/6UD5R7c78GAICao48wyae.mp4', 'timer.mp4', 'mp4', 149465619, 'C', '2021-08-12 14:22:58.379', '2021-08-12 14:24:01.327', 29, 5242880, 29, '6UD5R7c78GAICao48wyae');
INSERT INTO `file` VALUES ('zASEauy4', 'course/d2mpwBL6.blob', 'blob', 'blob', 20971520, 'C', '2021-08-10 12:12:42.727', '2021-08-10 12:12:42.727', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('ZeqF3rxK', 'course/MhpiDEjs.mp4', 'c1.mp4', 'mp4', 1854103, 'C', '2021-08-08 12:52:35.688', '2021-08-08 12:52:35.688', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('zICeMdDF', 'course/wA5F7Jme.jpeg', 'header2.jpeg', 'jpeg', 23099, 'C', '2021-08-08 21:34:32.193', '2021-08-08 21:34:32.193', NULL, NULL, NULL, NULL);
INSERT INTO `file` VALUES ('zlyBwa65', 'teacher/35t1Ye22I8q8gUWQG4OiI.png', '截屏2022-04-15 下午1.38.57.png', 'png', 1045602, 'T', '2022-04-15 13:39:17.698', '2022-04-15 13:39:17.698', 1, 5242880, 1, '35t1Ye22I8q8gUWQG4OiI');
INSERT INTO `file` VALUES ('ZSzAj91d', 'course/UBWo16jW.mp4', 'c2.mp4', 'mp4', 21492913, 'C', '2021-08-08 12:56:04.157', '2021-08-08 12:56:04.157', NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for member
-- ----------------------------
DROP TABLE IF EXISTS `member`;
CREATE TABLE `member` (
  `id` char(8) NOT NULL DEFAULT '' COMMENT 'id',
  `mobile` varchar(11) NOT NULL COMMENT '手机号',
  `password` char(32) NOT NULL COMMENT '密码',
  `name` varchar(50) DEFAULT NULL COMMENT '昵称',
  `photo` varchar(200) DEFAULT NULL COMMENT '头像url',
  `register_time` datetime(3) DEFAULT NULL COMMENT '注册时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mobile_unique` (`mobile`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会员';

-- ----------------------------
-- Records of member
-- ----------------------------
BEGIN;
INSERT INTO `member` VALUES ('00000000', '12345678901', 'e70e2222a9d67c4f2eae107533359aa4', '测试', NULL, '2021-08-24 10:19:31.000');
INSERT INTO `member` VALUES ('j8W5phjW', '18811345553', '610ad5531b49d9e93362bb4c5b98ed50', 'xiaozhe', NULL, '2021-08-25 17:06:37.660');
INSERT INTO `member` VALUES ('vLzeKfWk', '17753571351', '58be2adced42d3b4d1499f2c5168ac04', 'xiaozhe', NULL, '2021-08-24 13:05:18.630');
COMMIT;

-- ----------------------------
-- Table structure for member_course
-- ----------------------------
DROP TABLE IF EXISTS `member_course`;
CREATE TABLE `member_course` (
  `id` char(8) NOT NULL DEFAULT '' COMMENT 'id',
  `member_id` char(8) NOT NULL COMMENT '会员id',
  `course_id` char(8) NOT NULL COMMENT '课程id',
  `at` datetime(3) NOT NULL COMMENT '报名时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `member_course_unique` (`member_id`,`course_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会员课程报名';

-- ----------------------------
-- Records of member_course
-- ----------------------------
BEGIN;
INSERT INTO `member_course` VALUES ('2XNv0pAn', 'j8W5phjW', 'EQaDRgc9', '2022-04-14 22:12:56.936');
INSERT INTO `member_course` VALUES ('6j7I8Ids', 'j8W5phjW', 'vsQz6xVD', '2021-08-26 09:29:07.880');
COMMIT;

-- ----------------------------
-- Table structure for resource
-- ----------------------------
DROP TABLE IF EXISTS `resource`;
CREATE TABLE `resource` (
  `id` char(6) NOT NULL DEFAULT '' COMMENT 'id',
  `name` varchar(100) NOT NULL COMMENT '名称|菜单或按钮',
  `page` varchar(50) DEFAULT NULL COMMENT '页面|路由',
  `request` varchar(200) DEFAULT NULL COMMENT '请求|接口',
  `parent` char(6) DEFAULT NULL COMMENT '父id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='资源';

-- ----------------------------
-- Records of resource
-- ----------------------------
BEGIN;
INSERT INTO `resource` VALUES ('00', '欢迎', 'welcome', NULL, '');
INSERT INTO `resource` VALUES ('01', '系统管理', NULL, NULL, '');
INSERT INTO `resource` VALUES ('0101', '用户管理', 'system/user', NULL, '01');
INSERT INTO `resource` VALUES ('010101', '保存', NULL, '[\"/system/admin/user/list\",\"/system/admin/user/save\"]', '0101');
INSERT INTO `resource` VALUES ('010102', '删除', NULL, '[\"/system/admin/user/delete\"]', '0101');
INSERT INTO `resource` VALUES ('010103', '重置密码', NULL, '[\"/system/admin/user/save-password\"]', '0101');
INSERT INTO `resource` VALUES ('0102', '资源管理', 'system/resource', NULL, '01');
INSERT INTO `resource` VALUES ('010201', '保存/显示', NULL, '[\"/system/admin/resource\"]', '0102');
INSERT INTO `resource` VALUES ('0103', '角色管理', 'system/role', NULL, '01');
INSERT INTO `resource` VALUES ('010301', '角色/权限管理', NULL, '[\"/system/admin/role\"]', '0103');
INSERT INTO `resource` VALUES ('02', '业务管理', NULL, NULL, '');
INSERT INTO `resource` VALUES ('0201', '分类管理', 'business/category', NULL, '02');
INSERT INTO `resource` VALUES ('020101', '增删改查', NULL, '[\"/business/admin/category\"]', '0201');
INSERT INTO `resource` VALUES ('0202', '课程管理', 'business/course', NULL, '02');
INSERT INTO `resource` VALUES ('020201', '增删改查', NULL, '[\"/business/admin/course\",\"/business/admin/category/all\"]', '0202');
INSERT INTO `resource` VALUES ('0203', '讲师管理', 'business/teacher', NULL, '02');
INSERT INTO `resource` VALUES ('020301', '增删改查', NULL, '[\"/business/admin/teacher\"]', '0203');
INSERT INTO `resource` VALUES ('0204', '会员管理', 'business/member', NULL, '02');
INSERT INTO `resource` VALUES ('020401', '增删改查', NULL, '[\"/business/admin/member\"]', '0204');
INSERT INTO `resource` VALUES ('0205', '短信管理', 'business/sms', NULL, '02');
INSERT INTO `resource` VALUES ('020501', '增删改查', NULL, '[\"/business/admin/sms\"]', '0205');
INSERT INTO `resource` VALUES ('0206', '大章管理', 'business/chapter', NULL, '02');
INSERT INTO `resource` VALUES ('020601', '增删改查', NULL, '[\"/business/admin/chapter\"]', '0206');
INSERT INTO `resource` VALUES ('0207', '小节管理', 'business/section', NULL, '02');
INSERT INTO `resource` VALUES ('020701', '增删改查', NULL, '[\"/business/admin/section\"]', '0207');
INSERT INTO `resource` VALUES ('0208', '课程内容', 'business/content', NULL, '02');
INSERT INTO `resource` VALUES ('020801', '增删改查', NULL, '[\"/business/admin/course\",\"/business/admin/course-content-file\"]', '0208');
INSERT INTO `resource` VALUES ('03', '文件管理', NULL, NULL, '');
INSERT INTO `resource` VALUES ('0301', '文件管理', 'file/file', NULL, '03');
INSERT INTO `resource` VALUES ('030101', '文件管理', NULL, '[\"/file/admin/file\"]', '0301');
INSERT INTO `resource` VALUES ('030102', '文件验证', NULL, '[\"/file/admin/oss-check\"]', '0301');
INSERT INTO `resource` VALUES ('030103', '文件上传', NULL, '[\"/file/admin/oss-append\"]', '0301');
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` char(8) NOT NULL DEFAULT '' COMMENT 'id',
  `name` varchar(50) NOT NULL COMMENT '角色',
  `desc` varchar(100) NOT NULL COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色';

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES ('00000000', '系统管理员', '管理用户、角色权限');
INSERT INTO `role` VALUES ('00000001', '开发', '维护资源');
INSERT INTO `role` VALUES ('00000002', '业务管理员', '负责业务管理');
COMMIT;

-- ----------------------------
-- Table structure for role_resource
-- ----------------------------
DROP TABLE IF EXISTS `role_resource`;
CREATE TABLE `role_resource` (
  `id` char(8) NOT NULL DEFAULT '' COMMENT 'id',
  `role_id` char(8) NOT NULL COMMENT '角色|id',
  `resource_id` char(6) NOT NULL COMMENT '资源|id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色资源关联';

-- ----------------------------
-- Records of role_resource
-- ----------------------------
BEGIN;
INSERT INTO `role_resource` VALUES ('3qDvgCr3', '00000000', '010101');
INSERT INTO `role_resource` VALUES ('3utYj3hq', '00000001', '0203');
INSERT INTO `role_resource` VALUES ('3W3DFEN4', '00000000', '030102');
INSERT INTO `role_resource` VALUES ('71R5NrWS', '00000000', '0102');
INSERT INTO `role_resource` VALUES ('7LTQDoJ1', '00000001', '010103');
INSERT INTO `role_resource` VALUES ('7VXMKYdj', '00000000', '0205');
INSERT INTO `role_resource` VALUES ('8ItRLm9e', '00000000', '0203');
INSERT INTO `role_resource` VALUES ('9aKYONzz', '00000000', '020101');
INSERT INTO `role_resource` VALUES ('AlVAR1V7', '00000001', '01');
INSERT INTO `role_resource` VALUES ('CiLGxNQP', '00000000', '0103');
INSERT INTO `role_resource` VALUES ('d2y3q2wq', '00000000', '010103');
INSERT INTO `role_resource` VALUES ('dKyj4Yrl', '00000001', '020201');
INSERT INTO `role_resource` VALUES ('efG3Ek8c', '00000000', '0206');
INSERT INTO `role_resource` VALUES ('gX407DBg', '00000000', '010301');
INSERT INTO `role_resource` VALUES ('hsnPEYJD', '00000001', '0202');
INSERT INTO `role_resource` VALUES ('J4yoYqfZ', '00000000', '010201');
INSERT INTO `role_resource` VALUES ('JnSPC63f', '00000000', '020701');
INSERT INTO `role_resource` VALUES ('KlCbGrVT', '00000000', '01');
INSERT INTO `role_resource` VALUES ('LFBvEkpU', '00000000', '0301');
INSERT INTO `role_resource` VALUES ('LTOoRAsN', '00000000', '020801');
INSERT INTO `role_resource` VALUES ('MIyuliYj', '00000000', '030103');
INSERT INTO `role_resource` VALUES ('moPEJdrb', '00000001', '02');
INSERT INTO `role_resource` VALUES ('N835ijzo', '00000000', '0207');
INSERT INTO `role_resource` VALUES ('nizTUqz8', '00000000', '020401');
INSERT INTO `role_resource` VALUES ('NyS3iuRI', '00000000', '030101');
INSERT INTO `role_resource` VALUES ('o0EOd6eE', '00000000', '020501');
INSERT INTO `role_resource` VALUES ('ppUpFp7s', '00000000', '010102');
INSERT INTO `role_resource` VALUES ('qJfkhqHh', '00000000', '00');
INSERT INTO `role_resource` VALUES ('Silklp8C', '00000000', '02');
INSERT INTO `role_resource` VALUES ('STbn5Tbh', '00000001', '0101');
INSERT INTO `role_resource` VALUES ('sZd7a82J', '00000001', '0201');
INSERT INTO `role_resource` VALUES ('tTDnB59j', '00000001', '020301');
INSERT INTO `role_resource` VALUES ('tuvkC4Mm', '00000000', '03');
INSERT INTO `role_resource` VALUES ('USelio1s', '00000000', '0201');
INSERT INTO `role_resource` VALUES ('V3GtVQ2S', '00000000', '0204');
INSERT INTO `role_resource` VALUES ('vAPLBV7n', '00000000', '0208');
INSERT INTO `role_resource` VALUES ('vLKpop4P', '00000001', '020101');
INSERT INTO `role_resource` VALUES ('XOhmsfSs', '00000000', '0101');
INSERT INTO `role_resource` VALUES ('xWtARrIA', '00000000', '020301');
INSERT INTO `role_resource` VALUES ('Yp9KGy5B', '00000001', '010101');
INSERT INTO `role_resource` VALUES ('YrXwyNOT', '00000000', '020601');
INSERT INTO `role_resource` VALUES ('YUG93sYD', '00000000', '020201');
INSERT INTO `role_resource` VALUES ('Z0sfgfvL', '00000000', '0202');
COMMIT;

-- ----------------------------
-- Table structure for role_user
-- ----------------------------
DROP TABLE IF EXISTS `role_user`;
CREATE TABLE `role_user` (
  `id` char(8) NOT NULL DEFAULT '' COMMENT 'id',
  `role_id` char(8) NOT NULL COMMENT '角色|id',
  `user_id` char(8) NOT NULL COMMENT '用户|id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色用户关联';

-- ----------------------------
-- Records of role_user
-- ----------------------------
BEGIN;
INSERT INTO `role_user` VALUES ('50gcJP5x', '00000001', 'n7bz8IP9');
INSERT INTO `role_user` VALUES ('qj6sTcHk', '00000000', 'T4wswetU');
COMMIT;

-- ----------------------------
-- Table structure for section
-- ----------------------------
DROP TABLE IF EXISTS `section`;
CREATE TABLE `section` (
  `id` char(8) NOT NULL DEFAULT '' COMMENT 'id',
  `title` varchar(50) NOT NULL COMMENT '标题',
  `course_id` char(8) DEFAULT NULL COMMENT '课程|course.id',
  `chapter_id` char(8) DEFAULT NULL COMMENT '大章|chapter.id',
  `video` varchar(200) DEFAULT NULL COMMENT '视频',
  `time` int(11) DEFAULT NULL COMMENT '时长|单位秒',
  `charge` char(1) DEFAULT NULL COMMENT '收费|C 收费；F 免费',
  `sort` int(11) DEFAULT NULL COMMENT '顺序',
  `created_at` datetime(3) DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(3) DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='小节';

-- ----------------------------
-- Records of section
-- ----------------------------
BEGIN;
INSERT INTO `section` VALUES ('1vuPUACQ', 'MMMM', 'a2UqvQqI', 'abc6vQqI', 'http://127.0.0.1:9000/file/f/course/4K3OKKLA80ikuwkAQgMmqG.mp4', NULL, 'C', 6, '2021-08-12 15:39:24.702', '2021-08-12 15:39:24.702');
INSERT INTO `section` VALUES ('7LLpeUYd', 'CF2', 'a2UqvQqI', 'abc6vQqI', 'http://127.0.0.1:9000/file/f/course/4K3OKKLA80ikuwkAQgMmqG.mp4', NULL, 'C', 1, '2021-08-08 12:42:46.000', '2021-08-12 15:08:59.130');
INSERT INTO `section` VALUES ('aSOanUDb', 'Python最新课程', 'a2UqvQqI', 'abc6vQqI', 'https://douding-course.oss-cn-beijing.aliyuncs.com/course/4K3OKKLA80ikuwkAQgMmqG.mp4', NULL, 'C', 1, '2021-08-12 15:05:40.000', '2021-08-12 15:06:37.657');
INSERT INTO `section` VALUES ('asQz69f6', '第一节变量声明', 'a2UqvQqI', 'abc6vQqI', 'http://127.0.0.1:9000/file/f/course/rnaql56R.mp4', 59, 'C', 111, '2021-08-03 16:36:48.000', '2021-08-08 13:11:40.342');
INSERT INTO `section` VALUES ('gIb8BAZt', '第二节循环操作', 'a2UqvQqI', 'abc6vQqI', '1', 10, 'C', 1, '2021-08-05 09:39:37.000', '2021-08-08 12:42:20.437');
INSERT INTO `section` VALUES ('n7svwbJJ', 'CF手游最新视频', 'a2UqvQqI', 'abc6vQqI', 'http://127.0.0.1:9000/file/f/course/rnaql56z.mp4', 1076, 'C', NULL, '2021-08-08 13:23:57.000', '2021-08-11 10:51:32.135');
INSERT INTO `section` VALUES ('UtBN1RCi', '第二节服务器的启动', 'vsQz6xVD', '5ylAKc7S', 'https://douding-course.oss-cn-beijing.aliyuncs.com/course/4K3OKKLA80ikuwkAQgMmqG.mp4', 17, 'C', 2, '2021-08-23 17:23:27.000', '2021-08-23 18:12:53.758');
INSERT INTO `section` VALUES ('vsQz6fff', '第一节PHP下载环境', 'vsQz6xVD', '5ylAKc7S', 'https://douding-course.oss-cn-beijing.aliyuncs.com/course/6bdQgA9b5CawKigiSowIKe.mp4', 54, 'F', 1, '2021-08-03 13:07:39.000', '2022-04-16 15:47:25.508');
INSERT INTO `section` VALUES ('XYa0KzM9', 'PHP最新课程', 'a2UqvQqI', 'abc6vQqI', 'https://douding-course.oss-cn-beijing.aliyuncs.com/course/7tEMQAf3RmOImgQ4QaU4UY.mp4', 17, 'C', NULL, '2021-08-12 14:46:23.000', '2021-08-12 14:56:37.724');
COMMIT;

-- ----------------------------
-- Table structure for sms
-- ----------------------------
DROP TABLE IF EXISTS `sms`;
CREATE TABLE `sms` (
  `id` char(8) NOT NULL DEFAULT '' COMMENT 'id',
  `mobile` varchar(50) NOT NULL COMMENT '手机号',
  `code` char(6) NOT NULL COMMENT '验证码',
  `use` char(1) NOT NULL COMMENT '用途|枚举[SmsUseEnum]：REGISTER("R", "注册"), FORGET("F", "忘记密码")',
  `at` datetime(3) NOT NULL COMMENT '生成时间',
  `status` char(1) NOT NULL COMMENT '用途|枚举[SmsStatusEnum]：USED("U", "已使用"), NOT_USED("N", "未使用")',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='短信验证码';

-- ----------------------------
-- Records of sms
-- ----------------------------
BEGIN;
INSERT INTO `sms` VALUES ('00000000', '12345678901', '123456', 'R', '2021-08-25 15:53:12.000', 'N');
INSERT INTO `sms` VALUES ('AlCY9njf', '18811345553', '384302', 'R', '2021-08-25 17:04:41.420', 'N');
INSERT INTO `sms` VALUES ('KhG47yOF', '17753571351', '612633', 'F', '2021-08-25 17:10:41.706', 'N');
COMMIT;

-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
  `id` char(8) NOT NULL DEFAULT '' COMMENT 'id',
  `name` varchar(50) NOT NULL COMMENT '姓名',
  `nickname` varchar(50) DEFAULT NULL COMMENT '昵称',
  `image` varchar(100) DEFAULT NULL COMMENT '头像',
  `position` varchar(50) DEFAULT NULL COMMENT '职位',
  `motto` varchar(50) DEFAULT NULL COMMENT '座右铭',
  `intro` varchar(500) DEFAULT NULL COMMENT '简介',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='讲师';

-- ----------------------------
-- Records of teacher
-- ----------------------------
BEGIN;
INSERT INTO `teacher` VALUES ('5vkSWyOp', '王晨宇', 'jeffy', 'https://douding-course.oss-cn-beijing.aliyuncs.com/teacher/7Ds5xR5i7KC8u0UOCGqYw4.png', '阿里p7大佬', '拼搏努力,赢得人生精彩', '吉林大学');
INSERT INTO `teacher` VALUES ('I4IzEnVI', '张红海', '金牌', 'https://douding-course.oss-cn-beijing.aliyuncs.com/teacher/35t1Ye22I8q8gUWQG4OiI.png', '清华计算机硕士', '加油加油', '加油加油');
INSERT INTO `teacher` VALUES ('KU5kizJz', '张文华教授', 'jackzhang', 'https://douding-course.oss-cn-beijing.aliyuncs.com/teacher/7ggwV8hOoWEUaCUCei44S.png', '清华计算教授', '陈宫', '陈宫');
INSERT INTO `teacher` VALUES ('WhUmzll8', '刘海柱', '柱子', 'https://douding-course.oss-cn-beijing.aliyuncs.com/teacher/1AAsybGY20oWGg64cGO0ya.png', '高级讲师', '完胜', '完胜');
INSERT INTO `teacher` VALUES ('zxJ2ebX9', '林俊杰', 'jj', 'https://douding-course.oss-cn-beijing.aliyuncs.com/teacher/4MUPL5gwYwWEQmqSgigieq.png', '终极讲师', '坚持就是胜利', '清华大学');
COMMIT;

-- ----------------------------
-- Table structure for test
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `id` varchar(20) COLLATE utf8mb4_croatian_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_croatian_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_croatian_ci;

-- ----------------------------
-- Records of test
-- ----------------------------
BEGIN;
INSERT INTO `test` VALUES ('1', '肖喆');
INSERT INTO `test` VALUES ('2', '成龙');
INSERT INTO `test` VALUES ('3', 'wangfei');
INSERT INTO `test` VALUES ('4', '王妃');
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` char(8) NOT NULL DEFAULT '' COMMENT 'id',
  `login_name` varchar(50) NOT NULL COMMENT '登陆名',
  `name` varchar(50) DEFAULT NULL COMMENT '昵称',
  `password` char(32) NOT NULL COMMENT '密码',
  PRIMARY KEY (`id`),
  UNIQUE KEY `login_name_unique` (`login_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户';

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('10000000', 'test', '测试', 'e70e2222a9d67c4f2eae107533359aa4');
INSERT INTO `user` VALUES ('n7bz8IP9', 'wang', '王大刀', '610ad5531b49d9e93362bb4c5b98ed50');
INSERT INTO `user` VALUES ('qk2s5PS6', 'test2', 'alexnew', '610ad5531b49d9e93362bb4c5b98ed50');
INSERT INTO `user` VALUES ('T4wswetU', 'admin', 'alex', '1f15d405949c4ed3c2279aa6d48b1e9a');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
